Node / ReticulumProjects / MeshChatX.git / files / meshchatx / src / backend / database / config.py

Displaying Raw • Download

Tff7b72from T7ee787datetime Tff7b72import Te6edf3UTCTb4b4b4, Te6edf3datetime

Tff7b72from T7ee787.T7ee787provider Tff7b72import Te6edf3DatabaseProvider

Tff7b72class T56d364ConfigDAOTb4b4b4:

Tff7b72def Tff7b72__init__Tb4b4b4(Tff7b72selfTb4b4b4, Te6edf3providerTb4b4b4: Te6edf3DatabaseProviderTb4b4b4)Tb4b4b4:

Tff7b72selfTff7b72.Td2a8ffprovider Tff7b72= Te6edf3provider

Tff7b72def Td2a8ffgetTb4b4b4(Tff7b72selfTb4b4b4, Te6edf3keyTb4b4b4, Te6edf3defaultTff7b72=Tff7b72NoneTb4b4b4)Tb4b4b4:

Te6edf3row Tff7b72= Tff7b72selfTff7b72.Td2a8ffproviderTff7b72.Td2a8fffetchoneTb4b4b4(Ta5d6ff"Ta5d6ffSELECT value FROM config WHERE key = ?Ta5d6ff"Tb4b4b4, Tb4b4b4(Te6edf3keyTb4b4b4,Tb4b4b4)Tb4b4b4)

Tff7b72if Te6edf3rowTb4b4b4:

Tff7b72return Te6edf3rowTb4b4b4[Ta5d6ff"Ta5d6ffvalueTa5d6ff"Tb4b4b4]

Tff7b72return Te6edf3default

Tff7b72def Td2a8ffsetTb4b4b4(Tff7b72selfTb4b4b4, Te6edf3keyTb4b4b4, Te6edf3valueTb4b4b4)Tb4b4b4:

Tff7b72if Te6edf3value Tff7b72is Tff7b72NoneTb4b4b4:

Tff7b72selfTff7b72.Td2a8ffproviderTff7b72.Td2a8ffexecuteTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM config WHERE key = ?Ta5d6ff"Tb4b4b4, Tb4b4b4(Te6edf3keyTb4b4b4,Tb4b4b4)Tb4b4b4)

Tff7b72elseTb4b4b4:

Te6edf3now Tff7b72= Te6edf3datetimeTff7b72.Td2a8ffnowTb4b4b4(Te6edf3UTCTb4b4b4)

Tff7b72selfTff7b72.Td2a8ffproviderTff7b72.Td2a8ffexecuteTb4b4b4(

T8b949e"""

INSERT INTO config (key, value, created_at, updated_at)

VALUES (?, ?, ?, ?)

ON CONFLICT(key) DO UPDATE SET

value = EXCLUDED.value,

updated_at = EXCLUDED.updated_at

"""Tb4b4b4,

Tb4b4b4(Te6edf3keyTb4b4b4, Tffa657strTb4b4b4(Te6edf3valueTb4b4b4)Tb4b4b4, Te6edf3nowTb4b4b4, Te6edf3nowTb4b4b4)Tb4b4b4,

Tb4b4b4)

Tff7b72def Td2a8ffdeleteTb4b4b4(Tff7b72selfTb4b4b4, Te6edf3keyTb4b4b4)Tb4b4b4:

Tff7b72selfTff7b72.Td2a8ffproviderTff7b72.Td2a8ffexecuteTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM config WHERE key = ?Ta5d6ff"Tb4b4b4, Tb4b4b4(Te6edf3keyTb4b4b4,Tb4b4b4)Tb4b4b4)